package smartcommunityserver.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import smartcommunityserver.bean.BaseCount_2_Bean;

import java.util.List;

@Mapper
public interface BaseCount_2_Mapper {
    @Select("SELECT\n" +
            "    '处理中退款金额' as name ,\n" +
            "    processing_refund_amount as num\n" +
            "FROM refund_insights.refund_two\n" +
            "WHERE window_start = '2025-09-07 00:00:00'\n" +
            "GROUP BY name ,num\n" +
            "UNION ALL\n" +
            "SELECT\n" +
            "    '预计可挽回金额' as name ,\n" +
            "    total_estimated_recoverable_amount as num\n" +
            "FROM refund_insights.refund_two\n" +
            "WHERE window_start = '2025-09-07 00:00:00'\n" +
            "GROUP BY name ,num")
    List<BaseCount_2_Bean> baseCountMapper2();
}
